from sqlalchemy import Column, Integer, VARCHAR, TEXT
from models import Base


class UserModel(Base):
    __tablename__ = 'user'
    id = Column(Integer, primary_key=True)
    nickname = Column(VARCHAR(255))
    username = Column(VARCHAR(255))
    password = Column(VARCHAR(255))


class MusicModel(Base):
    __tablename__ = 'music'
    id = Column(Integer, primary_key=True)
    keyword = Column(VARCHAR(255))
    song_name = Column(VARCHAR(255))
    song_id = Column(VARCHAR(255))
    song_desc = Column(VARCHAR(255))
    singer_name = Column(VARCHAR(255))
    song_mid = Column(VARCHAR(255))
    album_id = Column(VARCHAR(255))
    song_url = Column(VARCHAR(255))
    my_song_url = Column(VARCHAR(255))
    thumb_url = Column(VARCHAR(255))
    my_thumb_url = Column(VARCHAR(255))
    lyric = Column(TEXT, default='')
    thumb_media_id = Column(VARCHAR(255), default="MpIpjVtUX1Nl-Qk9fTn4XQ9fFc18cH2dShzhKow2wB7aZrDw1ud0eqseNV0YnbOX")
    thumb_time = Column(VARCHAR(255))
    state = Column(VARCHAR(255), default="1")



